UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ss3xnWDbwBb5UgAumIRdc+P7H/dl+2y7z0LOWizEjt0='
WHERE
key_id = 'caa120678d7f1ba91e8e24f6a65cb6d3070b392f8dfad12906aedbdf385b836a'
AND (
token = 'ss3xnWDbwBb5UgAumIRdc+P7H/dl+2y7z0LOWizEjt0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)