UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6e84CtbWK6wgah0FgWN5Dora2JfFyrEBPoG15EQOLw4='
WHERE
key_id = '40880c25d721f70ddc2ab986293123dca069303eb274a5b513242f9b75f97ef8'
AND (
token = '6e84CtbWK6wgah0FgWN5Dora2JfFyrEBPoG15EQOLw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)