UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '//xt4r0D5GoM5KEt3FK+9e2rg6+FJxuCBiz24eqXWew='
WHERE
key_id = 'a299ecde50bd1f4aba1645946b64920edc038cc9e1fe0c849c70d179d47b8ad7'
AND (
token = '//xt4r0D5GoM5KEt3FK+9e2rg6+FJxuCBiz24eqXWew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)