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