UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VUjiihbnSyiNvla6+SmXLxK2o2d81efp8Jtw0hUokMU='
WHERE
key_id = 'd8ede7f76b482be1e37cd8409ca96b5c4e3c5800ae4cb8e4609aff524e5ff112'
AND (
token = 'VUjiihbnSyiNvla6+SmXLxK2o2d81efp8Jtw0hUokMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)