UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/BVICwUR1FRVXeou9UjuW7HJoLONeAXUUSa4glU4qJA='
WHERE
key_id = 'd6f8805d9650ba59137d996c887efe2c7fd1bd582feb2645158605ea551a6cfb'
AND (
token = '/BVICwUR1FRVXeou9UjuW7HJoLONeAXUUSa4glU4qJA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)