UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1JCiQWxSNR8eRUvLf/6T3M6481gdHAAVvw/86w7/tsM='
WHERE
key_id = '507c21670b61b25bea7972b9a6565dfa6e7b45cceee51374da363433a136430c'
AND (
token = '1JCiQWxSNR8eRUvLf/6T3M6481gdHAAVvw/86w7/tsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)