UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Zc5cRkJFoon+5uK6LycCDhXJE2MausPgfOcLOaxJX8='
WHERE
key_id = '0f12e339cd87ab8b7380ef6ab6b53961e805db0426b6b4198775dd2e440eaad2'
AND (
token = '1Zc5cRkJFoon+5uK6LycCDhXJE2MausPgfOcLOaxJX8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)