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