UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c9nR0Mho4aWN7VFti6xofpng0BihV4LG3W9S9F5qz1Y='
WHERE
key_id = '3a7771a4717f767dfb75daf13cf506de651637ff1ecb86b0a676adde624e9951'
AND (
token = 'c9nR0Mho4aWN7VFti6xofpng0BihV4LG3W9S9F5qz1Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)