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