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