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