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