UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6j6bkkiJSg9uXm7LW1K4xEBQL47p+DufPgmY0lVDGpc='
WHERE
key_id = '2c57cefbd2b0fbcfae0ba4d1a1a5de0a4d837273f9d766d368954508e59b7ee8'
AND (
token = '6j6bkkiJSg9uXm7LW1K4xEBQL47p+DufPgmY0lVDGpc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)