UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'idJA6Kv+ygJVTgLp+z8w/SGp9sbOXDBzob6KDJqQwdg='
WHERE
key_id = 'd8d65b1a673f785d76654c28fef72ca3d0ff289386f844b2d6433853ae03a5ce'
AND (
token = 'idJA6Kv+ygJVTgLp+z8w/SGp9sbOXDBzob6KDJqQwdg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)