UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W8eCwYFpCC9yih5E+ZmMZ3ndNSvMmxvFZQnNV6D6Xps='
WHERE
key_id = 'c163d5ba069b8fe118ff3fb65b7f0dfe17ae68611b790156bf89d9492d01e6fe'
AND (
token = 'W8eCwYFpCC9yih5E+ZmMZ3ndNSvMmxvFZQnNV6D6Xps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)