UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LnuOJ2WHNn4UtfphZVxk6jNJZcykDUHE2w7X9ZpBCWs='
WHERE
key_id = '28188adc9ab1674c7c19fa17bb7a592f607e54ddf73c5d792af80239fa693a5a'
AND (
token = 'LnuOJ2WHNn4UtfphZVxk6jNJZcykDUHE2w7X9ZpBCWs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)