UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LvjlYNmFZsv7y11cMV7dWSzW+jOUeskmYy5AEERhUnw='
WHERE
key_id = 'fdfb5b49cf66f8f3b4fe84b2720135fb5cd0290a6130eef2a5079e8ab6f9ef0c'
AND (
token = 'LvjlYNmFZsv7y11cMV7dWSzW+jOUeskmYy5AEERhUnw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)