UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SqM7p9TY0e8svhATBni6iOpljdEXgPqXYZGoboSYKT8='
WHERE
key_id = '8de2e1338d0ab5a5ae29ffdec2dc6b9bc01ecf1b8c4935172095fca617631fac'
AND (
token = 'SqM7p9TY0e8svhATBni6iOpljdEXgPqXYZGoboSYKT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)