UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rgN+ZCL47BBA9tZLhTtIA2PylitsDE62Xxxa8EnyotA='
WHERE
key_id = 'f66d88afc1fcd08fd900d845ca597fedb084c35a32ec4ac4be3f6e042ee75ee2'
AND (
token = 'rgN+ZCL47BBA9tZLhTtIA2PylitsDE62Xxxa8EnyotA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)