UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6IEj8Me03l5CvjRXCxyDOXLF77cWFvy3930cY0K5WAs='
WHERE
key_id = '42a1d0875e51e38553991af0c3d9e7a18cede85cf9ae4c5156e6e207db0fc96a'
AND (
token = '6IEj8Me03l5CvjRXCxyDOXLF77cWFvy3930cY0K5WAs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)