UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8MbU3hbHRG6rgcwMmlMqjM6eMm/0rhH03isbv+3vsgE='
WHERE
key_id = 'bb11965d58ddd26308678749d106844ec990b3b8462923a20e9cb80a9078f4cd'
AND (
token = '8MbU3hbHRG6rgcwMmlMqjM6eMm/0rhH03isbv+3vsgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)