UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/GShuVmjl1DiUJCfvnszP7Rw/LyU6+lppcmWKIEmJYA='
WHERE
key_id = '1e19ac0c1d5232f3e228503bb140077b18ff638596feea7a3aaba4a2b6a1a1d3'
AND (
token = '/GShuVmjl1DiUJCfvnszP7Rw/LyU6+lppcmWKIEmJYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)