UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VvjYL8/wX6moU0u5B+cnQXhZy4885SiXMtJXTPC/5bM='
WHERE
key_id = '8547587c65e59aeb5b497f826c5485dea9c5c8e531beda4ebc7a696f5b996a97'
AND (
token = 'VvjYL8/wX6moU0u5B+cnQXhZy4885SiXMtJXTPC/5bM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)