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