UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/UONQvYAjf5T5hSA/MVKiOB5KGQk1IXrIlxjCO6llh0='
WHERE
key_id = 'ddc3432f71e11951863b55629949c174a0049f356f8087adb830ce3bb4e37ec1'
AND (
token = '/UONQvYAjf5T5hSA/MVKiOB5KGQk1IXrIlxjCO6llh0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)