UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BRZnfPswmwQQ0BI0jgmiaxeT0FZf63jovk3CakN5cbc='
WHERE
key_id = '246cb886628b9690561afd96b76177c34ec2d22e2c44c1cc1019a5229414e178'
AND (
token = 'BRZnfPswmwQQ0BI0jgmiaxeT0FZf63jovk3CakN5cbc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)