UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ndN2ncFCQw9L0AObi0MjZ+htKUXeDuiW3kvOs5q+Tr4='
WHERE
key_id = 'fa530d1dbdff7206f6cf570ffd595fed47f135303361b9470a0e25152a2c2175'
AND (
token = 'ndN2ncFCQw9L0AObi0MjZ+htKUXeDuiW3kvOs5q+Tr4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)