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