UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PEpZyaB6VvK7HzY/yTVrwD7YDlFWSK2iQnubujSHsoU='
WHERE
key_id = 'bd138fc41b6537241d5739930afe80d0d001b760cf5b7851028e36b09a680144'
AND (
token = 'PEpZyaB6VvK7HzY/yTVrwD7YDlFWSK2iQnubujSHsoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)