UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zlWvM8hYSeEnK/FHHJdskw7yD5Rr100Xq6KxaE77zLk='
WHERE
key_id = '5a6c097e7dc1cc22e0db35c80f33a264a90198fdf80b7e4c7222d9b1e68809e8'
AND (
token = 'zlWvM8hYSeEnK/FHHJdskw7yD5Rr100Xq6KxaE77zLk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)