UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1jMYHC1LFE6XOA2OOhCNSwbAV7jYWr2kB0BCiaAgTjY='
WHERE
key_id = 'cf68e33c45b21bde929ea5ba7d5c16726e49bdc4b2df62d94176c231c57d78ac'
AND (
token = '1jMYHC1LFE6XOA2OOhCNSwbAV7jYWr2kB0BCiaAgTjY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)