UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nWTqzY8Ieq1owvz8SRGwlqLt8gfcQjqL1hQelCxBaCk='
WHERE
key_id = 'b7e5aa10b344c1278e2fcfb2dd37c3cc9d14aa33290d03a449f9768c73689b55'
AND (
token = 'nWTqzY8Ieq1owvz8SRGwlqLt8gfcQjqL1hQelCxBaCk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)