UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W6tpKU9XxpgaDFch4rVd1odApwcwBA69HcoWY7kw1AU='
WHERE
key_id = '1d08d9563a02f8ed4202a00c7167f55cdab0f88b4b2f5aaa62043b250e784000'
AND (
token = 'W6tpKU9XxpgaDFch4rVd1odApwcwBA69HcoWY7kw1AU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)