UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zsKIiUWJzoNczLiZ3qAmjW7J2BXW+xshB5jIMTBaOlg='
WHERE
key_id = 'efe026905323ad39033c62e3d1557a383cc4d12c9cb982a46ae5c12e7fee55a3'
AND (
token = 'zsKIiUWJzoNczLiZ3qAmjW7J2BXW+xshB5jIMTBaOlg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)